{
  "statement": "WITH tmp1 AS (\n\tSELECT\n\t\tbrand_no\n\tFROM\n\t\tbrand\n\tWHERE\n\t\tbrand_no IN ('BL01')\n),\ntmp2 AS (\n\tSELECT\n\t\torder_unit_no\n\tFROM\n\t\torder_unit\n\tWHERE\n\t\torder_unit_no IN ('Z002','E022','E150')\n),\ntmp_a AS (\n\tSELECT\n\t\tinb.*\n\tFROM\n\t\t(\n\t\t\tSELECT\n\t\t\t\tMIN(bc.id) AS id,\n\t\t\t\tbc.store_no,\n\t\t\t\tbcd.order_unit_no,\n\t\t\t\tbrand.sys_no brand_unit_no,\n\t\t\t\tSUM(bcd.real_qty) / COUNT( bc.check_date) AS check_qty\n\t\t\tFROM\n\t\t\t\tretail_pos.bill_checkstk bc\n\t\t\t\tINNER JOIN retail_pos.bill_checkstk_dtl bcd ON bc.bill_no = bcd.bill_no\n\t\t\t\tINNER JOIN brand ON brand.brand_no = bcd.brand_no\n\t\t\tWHERE\n\t\t\t\t1 = 1\n\t\t\t\tAND bcd.brand_no IN ('BL01')\n\t\t\t\tAND bcd.order_unit_no IN ('Z002')\n\t\t\t\tAND bc.check_type = 0\n\t\t\t\tAND bc.STATUS IN (5, 100)\n\t\t\t\tAND bc.sharding_flag = 'U010101_C'\n\t\t\t\tAND bcd.sharding_flag = 'U010101_C'\n\t\t\t\tAND length(bc.store_no) = 6\n\t\t\t\tAND (bc.store_no IN('CR05ZH'))\n\t\t\t\tAND bc.check_date >= str_to_date ('2022-07-13', '%Y-%m-%d')\n\t\t\t\tAND bc.check_date <= str_to_date ('2022-08-12', '%Y-%m-%d')\n\t\t\tGROUP BY\n\t\t\t\tbcd.order_unit_no,\n\t\t\t\tbc.store_no,\n\t\t\t\tbrand.sys_no\n\t\t) inb\n\t\tINNER JOIN order_unit ou ON inb.order_unit_no = ou.order_unit_no\n\t\tINNER JOIN organ o ON ou.organ_no = o.organ_no\n\tWHERE\n\t\t1 = 1\n\tORDER BY\n\t\tinb.id\n\tlimit\n\t\t0, 50\n), cte_exchange AS (\n\tSELECT\n\t\trem.shop_no,\n\t\tbrand.sys_no brand_unit_no,\n\t\tremD.qty,\n\t\trem.business_mode\n\tFROM\n\t\ttmp_a\n\t\tINNER JOIN retail_pos.return_exchange_main rem ON tmp_a.store_no = rem.shop_no\n\t\tINNER JOIN retail_pos.return_exchange_dtl remD ON rem.business_no = remD.business_no\n\t\tINNER JOIN brand ON brand.brand_no = remD.brand_no\n\t\tAND brand.sys_no = tmp_a.brand_unit_no\n\t\tINNER JOIN tmp1 ON remD.brand_no = tmp1.brand_no\n\tWHERE\n\t\t1 = 1\n\t\tAND rem.out_date >= str_to_date ('2022-07-13', '%Y-%m-%d')\n\t\tAND rem.out_date <= str_to_date ('2022-08-12', '%Y-%m-%d')\n\t\tAND rem.STATUS >= 30\n\t\tAND rem.sharding_flag = 'U010101_C'\n\t\tAND remD.sharding_flag = 'U010101_C'\n\t\tAND (rem.shop_no IN('CR05ZH'))\n)\nSELECT\n\tinbody.*\nFROM\n\t(\n\t\tSELECT\n\t\t\tE.order_unit_no,\n\t\t\tE.store_no,\n\t\t\tE.brand_unit_no,\n\t\t\tE.check_qty,\n\t\t\tE.diff_qty,\n\t\t\tE.send_out_qty,\n\t\t\tE.out_qty,\n\t\t\tE.exchange_qty\n\t\tFROM\n\t\t\t(\n\t\t\t\tSELECT\n\t\t\t\t\tD.order_unit_no,\n\t\t\t\t\tD.store_no,\n\t\t\t\t\tD.brand_unit_no,\n\t\t\t\t\tD.check_qty,\n\t\t\t\t\tD.diff_qty,\n\t\t\t\t\tD.send_out_qty,\n\t\t\t\t\tD.out_qty,\n\t\t\t\t\tSUM(ABS(rem.qty)) exchange_qty\n\t\t\t\tFROM\n\t\t\t\t\t(\n\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\tc.order_unit_no,\n\t\t\t\t\t\t\tc.store_no,\n\t\t\t\t\t\t\tc.brand_unit_no,\n\t\t\t\t\t\t\tc.check_qty,\n\t\t\t\t\t\t\tc.diff_qty,\n\t\t\t\t\t\t\tc.send_out_qty,\n\t\t\t\t\t\t\tSUM(ABS(rem.qty)) out_qty\n\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t\t\tb.order_unit_no,\n\t\t\t\t\t\t\t\t\tb.store_no,\n\t\t\t\t\t\t\t\t\tb.brand_unit_no,\n\t\t\t\t\t\t\t\t\tb.check_qty,\n\t\t\t\t\t\t\t\t\tb.diff_qty,\n\t\t\t\t\t\t\t\t\tSUM(sale.qty) send_out_qty\n\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t\t\t\t\tA.order_unit_no,\n\t\t\t\t\t\t\t\t\t\t\tA.store_no,\n\t\t\t\t\t\t\t\t\t\t\tA.brand_unit_no,\n\t\t\t\t\t\t\t\t\t\t\tA.check_qty,\n\t\t\t\t\t\t\t\t\t\t\tSUM(ABS(diff.diff_qty)) diff_qty\n\t\t\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t\t\ttmp_a A\n\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN (\n\t\t\t\t\t\t\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t\t\t\t\t\t\tdiff.store_no,\n\t\t\t\t\t\t\t\t\t\t\t\t\tdiffd.order_unit_no,\n\t\t\t\t\t\t\t\t\t\t\t\t\tbrand.sys_no brand_unit_no,\n\t\t\t\t\t\t\t\t\t\t\t\t\tdiffd.diff_qty\n\t\t\t\t\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t\t\t\t\ttmp_a\n\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN bill_check_diff diff ON tmp_a.store_no = diff.store_no\n\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN bill_check_diff_dtl diffd ON diff.bill_no = diffd.bill_no\n\t\t\t\t\t\t\t\t\t\t\t\t\tAND tmp_a.order_unit_no = diffd.order_unit_no\n\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN brand ON brand.brand_no = diffd.brand_no\n\t\t\t\t\t\t\t\t\t\t\t\t\tAND brand.sys_no = tmp_a.brand_unit_no\n\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN tmp1 ON diffd.brand_no = tmp1.brand_no\n\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN tmp2 ON diffd.order_unit_no = tmp2.order_unit_no\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\t\t\t1 = 1\n\t\t\t\t\t\t\t\t\t\t\t\t\tAND diff.STATUS NOT IN (0, 99)\n\t\t\t\t\t\t\t\t\t\t\t\t\tAND diff.sharding_flag = 'U010101_C'\n\t\t\t\t\t\t\t\t\t\t\t\t\tAND diffd.sharding_flag = 'U010101_C'\n\t\t\t\t\t\t\t\t\t\t\t\t\tAND diff.check_type = 0\n\t\t\t\t\t\t\t\t\t\t\t\t\tAND diff.check_date >= str_to_date ('2022-07-13', '%Y-%m-%d')\n\t\t\t\t\t\t\t\t\t\t\t\t\tAND diff.check_date <= str_to_date ('2022-08-12', '%Y-%m-%d')\n\t\t\t\t\t\t\t\t\t\t\t\t\tAND (diff.store_no IN('CR05ZH'))\n\t\t\t\t\t\t\t\t\t\t\t) diff ON A.store_no = diff.store_no\n\t\t\t\t\t\t\t\t\t\t\tAND A.order_unit_no = diff.order_unit_no\n\t\t\t\t\t\t\t\t\t\t\tAND A.brand_unit_no = diff.brand_unit_no\n\t\t\t\t\t\t\t\t\t\tGROUP BY\n\t\t\t\t\t\t\t\t\t\t\tA.order_unit_no,\n\t\t\t\t\t\t\t\t\t\t\tA.store_no,\n\t\t\t\t\t\t\t\t\t\t\tA.brand_unit_no,\n\t\t\t\t\t\t\t\t\t\t\tA.check_qty\n\t\t\t\t\t\t\t\t\t) b\n\t\t\t\t\t\t\t\t\tLEFT JOIN (\n\t\t\t\t\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t\t\t\t\tsale.shop_no,\n\t\t\t\t\t\t\t\t\t\t\tbrand.sys_no brand_unit_no,\n\t\t\t\t\t\t\t\t\t\t\tsaleDtl.qty\n\t\t\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t\t\ttmp_a\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN retail_pos.order_main sale ON tmp_a.store_no = sale.shop_no\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN retail_pos.order_dtl saleDtl ON sale.order_no = saleDtl.order_no\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN brand ON brand.brand_no = saleDtl.brand_no\n\t\t\t\t\t\t\t\t\t\t\tAND brand.sys_no = tmp_a.brand_unit_no\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN tmp1 ON saleDtl.brand_no = tmp1.brand_no\n\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\t1 = 1\n\t\t\t\t\t\t\t\t\t\t\tAND sale.STATUS > 30\n\t\t\t\t\t\t\t\t\t\t\tAND sale.out_date >= str_to_date ('2022-07-13', '%Y-%m-%d')\n\t\t\t\t\t\t\t\t\t\t\tAND sale.out_date <= str_to_date ('2022-08-12', '%Y-%m-%d')\n\t\t\t\t\t\t\t\t\t\t\tAND sale.business_type IN (0, 1)\n\t\t\t\t\t\t\t\t\t\t\tAND sale.sharding_flag = 'U010101_C'\n\t\t\t\t\t\t\t\t\t\t\tAND saleDtl.sharding_flag = 'U010101_C'\n\t\t\t\t\t\t\t\t\t\t\tAND (sale.shop_no IN('CR05ZH'))\n\t\t\t\t\t\t\t\t\t) sale ON sale.shop_no = b.store_no\n\t\t\t\t\t\t\t\t\tAND sale.brand_unit_no = b.brand_unit_no\n\t\t\t\t\t\t\t\tGROUP BY\n\t\t\t\t\t\t\t\t\tb.order_unit_no,\n\t\t\t\t\t\t\t\t\tb.store_no,\n\t\t\t\t\t\t\t\t\tb.brand_unit_no,\n\t\t\t\t\t\t\t\t\tb.check_qty,\n\t\t\t\t\t\t\t\t\tb.diff_qty\n\t\t\t\t\t\t\t) c\n\t\t\t\t\t\t\tLEFT JOIN (\n\t\t\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t\t\t*\n\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\tcte_exchange\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\tbusiness_mode = 2\n\t\t\t\t\t\t\t) rem ON c.store_no = rem.shop_no\n\t\t\t\t\t\t\tAND c.brand_unit_no = rem.brand_unit_no\n\t\t\t\t\t\tGROUP BY\n\t\t\t\t\t\t\tc.order_unit_no,\n\t\t\t\t\t\t\tc.store_no,\n\t\t\t\t\t\t\tc.brand_unit_no,\n\t\t\t\t\t\t\tc.check_qty,\n\t\t\t\t\t\t\tc.diff_qty,\n\t\t\t\t\t\t\tc.send_out_qty\n\t\t\t\t\t) D\n\t\t\t\t\tLEFT JOIN (\n\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t*\n\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\tcte_exchange\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\tbusiness_mode = 1\n\t\t\t\t\t\t\tAND qty < 0\n\t\t\t\t\t) rem ON D.store_no = rem.shop_no\n\t\t\t\t\tAND D.brand_unit_no = rem.brand_unit_no\n\t\t\t\tGROUP BY\n\t\t\t\t\tD.order_unit_no,\n\t\t\t\t\tD.store_no,\n\t\t\t\t\tD.brand_unit_no,\n\t\t\t\t\tD.check_qty,\n\t\t\t\t\tD.diff_qty,\n\t\t\t\t\tD.send_out_qty,\n\t\t\t\t\tD.out_qty\n\t\t\t) E\n\t\t\tLEFT JOIN (\n\t\t\t\tSELECT\n\t\t\t\t\tib.store_no,\n\t\t\t\t\tib.order_unit_no,\n\t\t\t\t\tbrand.sys_no brand_unit_no,\n\t\t\t\t\tib.bill_type,\n\t\t\t\t\tib.in_out_flag,\n\t\t\t\t\tib.balance_offset,\n\t\t\t\t\tib.original_bad_offset\n\t\t\t\tFROM\n\t\t\t\t\ttmp_a\n\t\t\t\t\tINNER JOIN inventory_book ib ON tmp_a.store_no = ib.store_no\n\t\t\t\t\tAND tmp_a.order_unit_no = ib.order_unit_no\n\t\t\t\t\tINNER JOIN brand ON brand.brand_no = ib.brand_no\n\t\t\t\t\tAND brand.sys_no = tmp_a.brand_unit_no\n\t\t\t\t\tINNER JOIN tmp1 ON ib.brand_no = tmp1.brand_no\n\t\t\t\t\tINNER JOIN tmp2 ON ib.order_unit_no = tmp2.order_unit_no\n\t\t\t\tWHERE\n\t\t\t\t\tib.bill_date >= str_to_date ('2022-07-13', '%Y-%m-%d')\n\t\t\t\t\tAND ib.bill_date <= str_to_date ('2022-08-12', '%Y-%m-%d')\n\t\t\t\t\tAND ib.sharding_flag = 'U010101_C'\n\t\t\t\t\tAND (ib.store_no IN('CR05ZH'))\n\t\t\t) ib ON E.store_no = ib.store_no\n\t) inbody\n\tINNER JOIN shop s ON s.shop_no = inbody.store_no\n\tINNER JOIN order_unit ou ON inbody.order_unit_no = ou.order_unit_no\n\tINNER JOIN organ o ON ou.organ_no = o.organ_no\n\tINNER JOIN zone_info z ON o.zone_no = z.zone_no\n\tINNER JOIN brand_unit bu ON bu.brand_unit_no = inbody.brand_unit_no;\n",
  "table_meta": {
    "retail_pos.bill_check_diff": "CREATE TABLE `bill_check_diff` (\n  `bill_no` varchar(30) NOT NULL COMMENT \"  \",\n  `create_time` datetime NOT NULL COMMENT \"  \",\n  `id` char(32) NULL COMMENT \"   (  D)\",\n  `bill_type` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `status` tinyint(4) NULL DEFAULT \"0\" COMMENT \"    0-制单,5确认 99作废)\",\n  `ref_bill_no` varchar(400) NULL COMMENT \"  \",\n  `ref_bill_type` int(11) NULL COMMENT \"  \",\n  `check_plan_no` char(30) NULL DEFAULT \"\" COMMENT \"  \",\n  `sys_no` char(18) NULL COMMENT \"  \",\n  `shop_no` char(18) NULL COMMENT \"  \",\n  `store_no` char(18) NULL COMMENT \"  \",\n  `store_name` varchar(100) NULL COMMENT \"  \",\n  `order_unit_no` char(18) NULL COMMENT \"  \",\n  `order_unit_name` varchar(100) NULL COMMENT \"  \",\n  `brand_no` varchar(2500) NULL DEFAULT \" \" COMMENT \"   (多个品牌用  隔)\",\n  `brand_name` varchar(4000) NULL COMMENT \"   (多个品牌名称用  隔)\",\n  `merchandiser` varchar(32) NULL COMMENT \"  \",\n  `price_type` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   -  1-现价\",\n  `check_type` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-全盘 1-抽盘 2-盲盘 3-试着盘点 4-盲盘（按货品）\",\n  `check_date` date NULL COMMENT \"  \",\n  `real_qty_total` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `inventory_qty_total` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `diff_qty_total` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `create_user` varchar(32) NULL COMMENT \"  \",\n  `auditor` varchar(32) NULL COMMENT \"  \",\n  `audit_time` datetime NULL COMMENT \"  \",\n  `update_time` datetime NULL COMMENT \"  \",\n  `remark` varchar(255) NULL COMMENT \"  \",\n  `zone_yyyymm` char(8) NULL COMMENT \"    区\",\n  `sharding_flag` char(20) NULL COMMENT \"    区\",\n  `share_config` tinyint(4) NULL DEFAULT \"0\" COMMENT \"    0-共享可配；1-不共享可配；2-不共享不可配)\",\n  `sell_return_code` varchar(32) NULL COMMENT \"  \",\n  `wms_bill_no` varchar(32) NULL COMMENT \"  \",\n  `net_work_sale_type_code` varchar(64) NULL COMMENT \"  \",\n  `net_work_sale_type_value` varchar(100) NULL COMMENT \"  \",\n  `headless_order_bill_no` varchar(30) NULL COMMENT \"  \",\n  `price_sync_flag` tinyint(4) NULL COMMENT \"   0:未同步，1：已同步\"\n) ENGINE=OLAP \nPRIMARY KEY(`bill_no`, `create_time`)\nCOMMENT \"    头\"\nPARTITION BY RANGE(`create_time`)\n()\nDISTRIBUTED BY HASH(`bill_no`) BUCKETS 4 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"bloom_filter_columns\" = \"store_no\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"true\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);",
    "retail_pos.bill_check_diff_dtl": "CREATE TABLE `bill_check_diff_dtl` (\n  `bill_no` varchar(30) NOT NULL COMMENT \"  \",\n  `id` varchar(32) NOT NULL COMMENT \"   (  D)\",\n  `create_time` datetime NOT NULL COMMENT \"  \",\n  `seq_id` int(11) NULL COMMENT \"  \",\n  `sku_no` varchar(32) NULL COMMENT \"  \",\n  `item_no` char(18) NULL COMMENT \"  \",\n  `barcode` varchar(50) NULL COMMENT \"  \",\n  `item_code` varchar(30) NULL COMMENT \"  \",\n  `item_name` varchar(200) NULL COMMENT \"  \",\n  `color_no` char(18) NULL COMMENT \"  \",\n  `color_name` varchar(50) NULL COMMENT \"  \",\n  `brand_no` char(18) NULL COMMENT \"  \",\n  `brand_name` varchar(200) NULL COMMENT \"  \",\n  `category_no` char(18) NULL COMMENT \"  \",\n  `size_no` varchar(10) NULL COMMENT \"  \",\n  `size_kind` char(2) NULL COMMENT \"  \",\n  `stock_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `real_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `diff_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `cost` decimal64(12, 2) NULL DEFAULT \"0.00\" COMMENT \"  \",\n  `inventory_type` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `check_plan_no` varchar(30) NULL DEFAULT \"\" COMMENT \"  \",\n  `region_cost` decimal64(12, 2) NULL COMMENT \"  \",\n  `manufacture_cost` decimal64(14, 4) NULL COMMENT \"  \",\n  `factory_price` decimal64(12, 2) NULL COMMENT \"  \",\n  `headquarter_cost` decimal64(12, 2) NULL COMMENT \"  \",\n  `remark` varchar(255) NULL COMMENT \"  \",\n  `order_unit_no` char(18) NULL COMMENT \"  \",\n  `company_no` char(18) NULL COMMENT \"  \",\n  `order_unit_name` varchar(100) NULL COMMENT \"  \",\n  `update_time` datetime NULL COMMENT \"  \",\n  `zone_yyyymm` char(8) NULL COMMENT \"    区\",\n  `price` decimal64(12, 2) NULL DEFAULT \"0.00\" COMMENT \"  \",\n  `sharding_flag` char(20) NULL COMMENT \"    区\",\n  `purchase_price` decimal64(14, 4) NULL DEFAULT \"0.0000\" COMMENT \"  \",\n  `check_reason` varchar(100) NULL COMMENT \"  \",\n  `check_remark` varchar(255) NULL COMMENT \"  \",\n  `settle_price` decimal64(12, 2) NULL DEFAULT \"0.00\" COMMENT \"  \",\n  `curr_price` decimal64(12, 2) NULL DEFAULT \"0.00\" COMMENT \"  \"\n) ENGINE=OLAP \nPRIMARY KEY(`bill_no`, `id`, `create_time`)\nCOMMENT \"    体\"\nPARTITION BY RANGE(`create_time`)\n()\nDISTRIBUTED BY HASH(`bill_no`) BUCKETS 4 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"true\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);",
    "retail_pos.bill_checkstk": "CREATE TABLE `bill_checkstk` (\n  `bill_no` varchar(30) NOT NULL COMMENT \"  \",\n  `create_time` datetime NOT NULL COMMENT \"  \",\n  `id` char(32) NULL COMMENT \"   ,uu  成\",\n  `bill_type` smallint(6) NULL COMMENT \"   ,  7-盘点单\",\n  `status` tinyint(4) NULL COMMENT \"   0-制单 5-确定 默认为0 99-作废\",\n  `check_date` date NULL COMMENT \"  \",\n  `shop_no` char(18) NULL COMMENT \"  \",\n  `shop_name` varchar(100) NULL COMMENT \"  \",\n  `store_no` char(18) NULL COMMENT \"  \",\n  `store_name` varchar(100) NULL COMMENT \"  \",\n  `brand_no` varchar(2500) NULL COMMENT \"  \",\n  `brand_name` varchar(4000) NULL COMMENT \"  \",\n  `check_type` tinyint(4) NULL COMMENT \"   0-全盘 1-抽盘 2-盲盘 3-试着盘点 4-盲盘(按货品)\",\n  `check_item_groupno` varchar(2000) NULL COMMENT \"   ,商品  述(商品组名称)\",\n  `check_mode` tinyint(4) NULL DEFAULT \"2\" COMMENT \"    工,2-盘点器\",\n  `inv_snapshoot_type` tinyint(4) NULL COMMENT \"  \",\n  `inv_snapshoot_date` datetime NULL COMMENT \"  \",\n  `snapshoot_sign` tinyint(4) NULL COMMENT \"   =未  1=已生成\",\n  `sys_no` char(10) NULL DEFAULT \"00\" COMMENT \"  \",\n  `ref_bill_no` char(30) NULL COMMENT \"  \",\n  `ref_bill_type` smallint(6) NULL COMMENT \"  \",\n  `supervisor` varchar(32) NULL COMMENT \"  \",\n  `merchandiser` varchar(32) NULL COMMENT \"  \",\n  `create_user` varchar(32) NULL COMMENT \"  \",\n  `auditor` varchar(32) NULL COMMENT \"  \",\n  `audit_time` datetime NULL COMMENT \"  \",\n  `remark` varchar(255) NULL COMMENT \"  \",\n  `upload_remark` varchar(255) NULL COMMENT \"  \",\n  `update_user` varchar(32) NULL COMMENT \"  \",\n  `update_time` datetime NULL COMMENT \"  \",\n  `sharding_flag` varchar(20) NULL COMMENT \"  \",\n  `recheck_audit_time` datetime NULL COMMENT \"  \",\n  `recheck_auditor` varchar(32) NULL COMMENT \"  \",\n  `check_month` varchar(20) NULL COMMENT \"    盘]\"\n) ENGINE=OLAP \nPRIMARY KEY(`bill_no`, `create_time`)\nCOMMENT \"  \"\nPARTITION BY RANGE(`create_time`)\n()\nDISTRIBUTED BY HASH(`bill_no`) BUCKETS 8 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"bloom_filter_columns\" = \"shop_no\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"true\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);",
    "retail_pos.bill_checkstk_dtl": "CREATE TABLE `bill_checkstk_dtl` (\n  `bill_no` varchar(30) NOT NULL COMMENT \"  \",\n  `id` varchar(38) NOT NULL COMMENT \"   ,uu  成\",\n  `create_time` datetime NOT NULL COMMENT \"  \",\n  `sku_no` char(32) NULL COMMENT \"  \",\n  `seq_id` int(11) NULL COMMENT \"  \",\n  `item_no` char(18) NULL COMMENT \"  \",\n  `item_code` varchar(30) NULL COMMENT \"   (出厂时的  码)\",\n  `item_name` varchar(200) NULL COMMENT \"  \",\n  `color_no` varchar(18) NULL COMMENT \"  \",\n  `color_name` varchar(50) NULL COMMENT \"  \",\n  `brand_no` char(18) NULL COMMENT \"  \",\n  `brand_name` varchar(200) NULL COMMENT \"  \",\n  `order_unit_no` char(18) NULL COMMENT \"  \",\n  `order_unit_name` varchar(100) NULL COMMENT \"  \",\n  `size_no` varchar(10) NULL COMMENT \"  \",\n  `inventory_qty` int(11) NULL COMMENT \"  \",\n  `real_qty` int(11) NULL COMMENT \"  \",\n  `diff_qty` int(11) NULL COMMENT \"  \",\n  `quote_price` decimal64(8, 2) NULL COMMENT \"  \",\n  `size_kind` char(2) NULL COMMENT \"  \",\n  `barcode` varchar(50) NULL COMMENT \"  \",\n  `category_no` char(18) NULL COMMENT \"  \",\n  `location_no` varchar(100) NULL COMMENT \"  \",\n  `inventory_type` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   \",\n  `group_no` varchar(10) NULL COMMENT \"  \",\n  `order_num` int(11) NULL COMMENT \"  \",\n  `terminal_no` varchar(30) NULL COMMENT \"   (包括移动设备  器)\",\n  `merchandiser` varchar(32) NULL COMMENT \"  \",\n  `create_user` varchar(32) NULL COMMENT \"  \",\n  `update_user` varchar(32) NULL COMMENT \"  \",\n  `update_time` datetime NULL COMMENT \"  \",\n  `sharding_flag` varchar(20) NULL COMMENT \"  \",\n  `style_no` varchar(30) NULL COMMENT \"  \",\n  `plate_code` varchar(40) NULL COMMENT \"  \",\n  `rfid_dtl_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \"\n) ENGINE=OLAP \nPRIMARY KEY(`bill_no`, `id`, `create_time`)\nCOMMENT \"  \"\nPARTITION BY RANGE(`create_time`)\n()\nDISTRIBUTED BY HASH(`bill_no`) BUCKETS 16 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"bloom_filter_columns\" = \"item_no\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"true\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);",
    "retail_pos.brand": "CREATE TABLE `brand` (\n  `brand_no` varchar(18) NOT NULL COMMENT \"  \",\n  `id` int(11) NULL COMMENT \"  \",\n  `name` varchar(200) NULL COMMENT \"  \",\n  `en_name` varchar(200) NULL COMMENT \"  \",\n  `en_short_name` varchar(200) NULL COMMENT \"  \",\n  `opcode` char(2) NULL COMMENT \"   (用于鞋类商品编码的  母,必须输入且只能输入一位字符)\",\n  `category` varchar(20) NULL COMMENT \"   D:代理品牌，S:自有品牌)\",\n  `belonger` varchar(20) NULL COMMENT \"   X:鞋，S:体)\",\n  `status` tinyint(4) NULL DEFAULT \"1\" COMMENT \"   0 = 撤消 1 = 正常)\",\n  `sys_no` varchar(10) NULL DEFAULT \"00\" COMMENT \"   (关联品  码)\",\n  `search_code` varchar(10) NULL COMMENT \"  \",\n  `parent_brand_id` int(11) NULL COMMENT \"  \",\n  `logo_url` varchar(200) NULL COMMENT \"  \",\n  `create_user` varchar(32) NULL COMMENT \"  \",\n  `create_time` datetime NULL COMMENT \"  \",\n  `update_user` varchar(32) NULL COMMENT \"  \",\n  `update_time` datetime NULL COMMENT \"  \",\n  `remark` varchar(255) NULL DEFAULT \"\" COMMENT \"  \",\n  `time_seq` bigint(20) NULL COMMENT \"  \",\n  `organ_type_no` varchar(50) NULL COMMENT \"  \"\n) ENGINE=OLAP \nPRIMARY KEY(`brand_no`)\nCOMMENT \"   (ot  表-来源mdm)\"\nDISTRIBUTED BY HASH(`brand_no`) BUCKETS 4 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"true\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);",
    "retail_pos.brand_unit": "CREATE TABLE `brand_unit` (\n  `brand_unit_no` varchar(18) NOT NULL COMMENT \"  \",\n  `id` int(11) NULL COMMENT \"  \",\n  `code` varchar(10) NULL COMMENT \"  \",\n  `name` varchar(50) NULL COMMENT \"  \",\n  `name_short` varchar(10) NULL COMMENT \"  \",\n  `status` tinyint(4) NULL DEFAULT \"1\" COMMENT \"   0 = 撤消 1 = 正常)\",\n  `create_user` varchar(32) NULL COMMENT \"  \",\n  `create_time` datetime NULL COMMENT \"  \",\n  `update_user` varchar(32) NULL COMMENT \"  \",\n  `update_time` datetime NULL COMMENT \"  \",\n  `remark` varchar(255) NULL DEFAULT \"\" COMMENT \"  \",\n  `time_seq` bigint(20) NULL COMMENT \"  \",\n  `organ_type_no` varchar(50) NULL COMMENT \"  \"\n) ENGINE=OLAP \nPRIMARY KEY(`brand_unit_no`)\nCOMMENT \"  \"\nDISTRIBUTED BY HASH(`brand_unit_no`) BUCKETS 4 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"true\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);",
    "retail_pos.inventory_book": "CREATE TABLE `inventory_book` (\n  `id` varchar(32) NOT NULL COMMENT \"  \",\n  `sku_no` varchar(32) NOT NULL COMMENT \"  \",\n  `bill_date` date NOT NULL DEFAULT \"2000-01-01\" COMMENT \"  \",\n  `store_no_from` char(18) NULL DEFAULT \"\" COMMENT \"  \",\n  `store_name_from` varchar(100) NULL DEFAULT \"\" COMMENT \"  \",\n  `store_no_to` char(18) NULL DEFAULT \"\" COMMENT \"  \",\n  `store_name_to` varchar(100) NULL DEFAULT \"\" COMMENT \"  \",\n  `order_unit_no_from` char(18) NULL DEFAULT \"\" COMMENT \"  \",\n  `order_unit_name_from` varchar(100) NULL DEFAULT \"\" COMMENT \"  \",\n  `order_unit_no_to` char(18) NULL DEFAULT \"\" COMMENT \"  \",\n  `order_unit_name_to` varchar(100) NULL DEFAULT \"\" COMMENT \"  \",\n  `store_no` char(18) NULL DEFAULT \"\" COMMENT \"  \",\n  `store_name` varchar(100) NULL DEFAULT \"\" COMMENT \"  \",\n  `company_no` char(18) NULL COMMENT \"  \",\n  `order_unit_no` char(18) NOT NULL DEFAULT \"\" COMMENT \"  \",\n  `order_unit_name` varchar(100) NULL DEFAULT \"\" COMMENT \"  \",\n  `item_no` char(18) NULL DEFAULT \"\" COMMENT \"  \",\n  `item_code` varchar(30) NULL DEFAULT \"\" COMMENT \"   (出厂时的  码)\",\n  `item_name` char(200) NULL COMMENT \"  \",\n  `brand_no` char(18) NULL COMMENT \"  \",\n  `brand_name` varchar(200) NULL DEFAULT \"\" COMMENT \"  \",\n  `category_no` char(18) NULL COMMENT \"  \",\n  `size_no` varchar(10) NULL COMMENT \"  \",\n  `size_kind` char(2) NOT NULL DEFAULT \"\" COMMENT \"  \",\n  `bill_no` char(30) NOT NULL DEFAULT \"\" COMMENT \"  \",\n  `status` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `bill_type` int(11) NOT NULL DEFAULT \"0\" COMMENT \"  \",\n  `in_out_flag` tinyint(4) NOT NULL DEFAULT \"0\" COMMENT \"   (从sys_stan  d(主表)获取,sys_standard_dtl(明细表),lookup_code:IN_OUT_FLAG)\",\n  `ref_bill_no` varchar(200) NULL DEFAULT \"\" COMMENT \"  \",\n  `ref_bill_type` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `biz_type` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `account_type` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   :记非  存,1：记实物库存 -1弃用,2记实物和非实物库存\",\n  `cost` decimal64(12, 2) NULL DEFAULT \"0.00\" COMMENT \"  \",\n  `balance_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `balance_qty` int(11) NULL DEFAULT \"0\" COMMENT \"   (商品库存账Inventory  量)\",\n  `bclass_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `bclass_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `bclass_occupied_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `bclass_occupied_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `factory_in_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `factory_in_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `factory_in_diff_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `factory_in_diff_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `transit_in_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `transit_in_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `transit_out_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `transit_out_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `in_diff_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `in_diff_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `out_diff_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `out_diff_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `transit_in_account_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `transit_in_account_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `transit_out_account_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `transit_out_account_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `in_diff_account_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `in_diff_account_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `out_diff_account_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `out_diff_account_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `lock_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `lock_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `occupied_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `occupied_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `backup_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `backup_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `guest_bad_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `guest_bad_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `original_bad_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `original_bad_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `bad_transit_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `bad_transit_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `bad_diff_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `bad_diff_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `return_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `return_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `borrow_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `borrow_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `ecommerce_offset` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `ecommerce_qty` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `create_time` datetime NOT NULL DEFAULT \"2000-01-01 00:00:00\" COMMENT \"  \",\n  `create_timestamp` datetime NULL DEFAULT \"2000-01-01 00:00:00\" COMMENT \"  \",\n  `update_time` datetime NOT NULL COMMENT \"  \",\n  `sharding_flag` char(20) NULL DEFAULT \"\" COMMENT \"    区\",\n  `origin_bill_no` varchar(30) NULL DEFAULT \"\" COMMENT \"  \",\n  INDEX inx_store_no (`store_no`) USING BITMAP COMMENT '  ',\n  INDEX inx_order_unit_no (`order_unit_no`) USING BITMAP COMMENT '  '\n) ENGINE=OLAP \nPRIMARY KEY(`id`, `sku_no`, `bill_date`)\nCOMMENT \"  \"\nPARTITION BY RANGE(`bill_date`)\n(PARTITION p202304 VALUES [(\"2023-04-01\"), (\"2023-05-01\")),\nPARTITION p202305 VALUES [(\"2023-05-01\"), (\"2023-06-01\")))\nDISTRIBUTED BY HASH(`sku_no`) BUCKETS 16 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"bloom_filter_columns\" = \"item_code, sku_no, bill_no, item_no\",\n\"dynamic_partition.enable\" = \"true\",\n\"dynamic_partition.time_unit\" = \"MONTH\",\n\"dynamic_partition.time_zone\" = \"Asia/Shanghai\",\n\"dynamic_partition.start\" = \"-2147483648\",\n\"dynamic_partition.end\" = \"1\",\n\"dynamic_partition.prefix\" = \"p\",\n\"dynamic_partition.buckets\" = \"16\",\n\"dynamic_partition.history_partition_num\" = \"0\",\n\"dynamic_partition.start_day_of_month\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"true\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);",
    "retail_pos.order_dtl": "CREATE TABLE `order_dtl` (\n  `order_no` varchar(25) NOT NULL COMMENT \"  \",\n  `id` varchar(32) NOT NULL COMMENT \"   ,uu  成\",\n  `out_date` date NOT NULL DEFAULT \"2000-01-01\" COMMENT \"  \",\n  `ref_bill_no` char(30) NULL COMMENT \"  \",\n  `shop_no` char(18) NULL COMMENT \"  \",\n  `shop_name` varchar(100) NULL COMMENT \"  \",\n  `shop_no_from` char(18) NULL COMMENT \"    货)门店编码\",\n  `shop_name_from` varchar(100) NULL COMMENT \"    货)门店\",\n  `sku_no` char(32) NOT NULL COMMENT \"  \",\n  `item_no` char(18) NOT NULL COMMENT \"  \",\n  `size_no` varchar(10) NOT NULL COMMENT \"  \",\n  `item_code` varchar(30) NULL COMMENT \"  \",\n  `item_name` varchar(200) NULL COMMENT \"  \",\n  `barcode` varchar(50) NULL COMMENT \"  \",\n  `brand_no` varchar(18) NOT NULL COMMENT \"  \",\n  `item_flag` tinyint(4) NOT NULL DEFAULT \"0\" COMMENT \"  \",\n  `tag_price` decimal128(20, 2) NULL COMMENT \"  \",\n  `sale_price` decimal128(20, 2) NULL COMMENT \"  \",\n  `disc_price` decimal128(20, 2) NULL COMMENT \"  \",\n  `settle_price` decimal128(20, 2) NULL COMMENT \"  \",\n  `reduce_price` decimal128(20, 2) NULL COMMENT \"   ,  价\",\n  `rebate_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `score_amount` decimal128(20, 2) NULL DEFAULT \"0.00\" COMMENT \"  \",\n  `qty` int(11) NULL COMMENT \"  \",\n  `amount` decimal128(20, 2) NULL COMMENT \"   ,  价-减价)*数量\",\n  `pref_price` decimal128(20, 2) NULL COMMENT \"   ,促销  价\",\n  `pro_no` varchar(130) NULL COMMENT \"  \",\n  `pro_name` varchar(310) NULL COMMENT \"  \",\n  `special_sell_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-正常 1-特卖\",\n  `discount` decimal64(10, 4) NULL COMMENT \"     7.00代表17.00%\",\n  `discount_code` varchar(10) NULL COMMENT \"   B\",\n  `discount_name` varchar(100) NULL COMMENT \"  \",\n  `discount_type` tinyint(4) NULL COMMENT \"  \",\n  `discount_type_name` varchar(50) NULL COMMENT \"  \",\n  `discount_source_id` varchar(36) NULL COMMENT \"  \",\n  `billing_code` varchar(32) NULL COMMENT \"  \",\n  `properties` tinyint(4) NULL COMMENT \"   1-满送 2-满减 3-折扣 4-其他 5-买当\",\n  `virtual_flag` tinyint(4) NULL COMMENT \"   0-虚数 1-实数\",\n  `strength` decimal64(8, 2) NULL COMMENT \"  \",\n  `activity_type_name` varchar(100) NULL COMMENT \"  \",\n  `activity_type` tinyint(4) NULL COMMENT \"  \",\n  `launch_type_name` varchar(100) NULL COMMENT \"  \",\n  `launch_type` tinyint(4) NULL COMMENT \"  \",\n  `pro_end_time` datetime NULL COMMENT \"  \",\n  `pro_start_time` datetime NULL COMMENT \"  \",\n  `balance_base` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-销售金额 1-牌价金额\",\n  `vip_discount` decimal64(10, 4) NULL COMMENT \"  \",\n  `vip_level_name` varchar(64) NULL COMMENT \"  \",\n  `vip_level_code` varchar(10) NULL COMMENT \"  \",\n  `base_score` int(11) NOT NULL DEFAULT \"0\" COMMENT \"  \",\n  `pro_score` int(11) NOT NULL DEFAULT \"0\" COMMENT \"  \",\n  `cost_score` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `item_discount` decimal64(10, 4) NULL COMMENT \"     5.00代表25.00%\",\n  `color_no` varchar(18) NULL COMMENT \"  \",\n  `color_name` varchar(50) NULL COMMENT \"  \",\n  `brand_name` varchar(200) NULL COMMENT \"  \",\n  `reduce_price_reason` varchar(255) NULL COMMENT \"  \",\n  `reason_class_name` varchar(100) NULL COMMENT \"  \",\n  `reason_class_no` varchar(10) NULL COMMENT \"  \",\n  `reason_code` varchar(50) NULL COMMENT \"  \",\n  `size_kind` char(2) NULL COMMENT \"  \",\n  `category_no` char(18) NULL COMMENT \"  \",\n  `bill_transfer_no` varchar(36) NULL COMMENT \"  \",\n  `price_change_bill_no` varchar(40) NULL COMMENT \"  \",\n  `return_exchange_num` smallint(6) NULL DEFAULT \"0\" COMMENT \"  \",\n  `zone_yyyymm` char(8) NULL COMMENT \"  \",\n  `across_sale_flag` tinyint(4) NULL DEFAULT \"1\" COMMENT \"   0-否 1-是\",\n  `specified_discount_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   \",\n  `pickup_status` tinyint(4) NULL DEFAULT \"1\" COMMENT \"  \",\n  `take_off_type` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `pickup_user` varchar(32) NULL COMMENT \"  \",\n  `pickup_user_no` varchar(20) NULL COMMENT \"  \",\n  `pickup_time` datetime NULL COMMENT \"  \",\n  `invoice_no` varchar(255) NULL COMMENT \"     S),多个用逗号(,)分隔\",\n  `actual_amount` decimal128(20, 2) NULL DEFAULT \"0.00\" COMMENT \"   (优  值+结算金额)\",\n  `real_buy_amount` decimal128(20, 2) NULL DEFAULT \"0.00\" COMMENT \"   (优惠券  额)\",\n  `surplus_amount` decimal128(20, 2) NULL DEFAULT \"0.00\" COMMENT \"   (优  值)\",\n  `rate_discount` decimal128(20, 4) NULL DEFAULT \"0.0000\" COMMENT \"  \",\n  `dtl_refund_status` tinyint(4) NULL DEFAULT \"30\" COMMENT \"      款 20 退款成功 30 未退款\",\n  `create_user` varchar(32) NULL COMMENT \"  \",\n  `create_time` datetime NULL COMMENT \"  \",\n  `update_user` varchar(32) NULL COMMENT \"  \",\n  `update_time` datetime NOT NULL COMMENT \"  \",\n  `sharding_flag` varchar(20) NULL COMMENT \"  \",\n  `style_no` varchar(30) NULL COMMENT \"  \",\n  `change_state` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `change_audit_state` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `change_state_audit_user` varchar(32) NULL COMMENT \"  \",\n  `change_state_audit_time` datetime NULL COMMENT \"  \",\n  `rate_pro_no` varchar(130) NULL COMMENT \"  \",\n  `rate_pro_name` varchar(130) NULL COMMENT \"  \",\n  `biz_city_no` char(18) NULL COMMENT \"  \",\n  `biz_city_name` varchar(240) NULL COMMENT \"  \",\n  `organ_no` char(18) NULL COMMENT \"  \",\n  `organ_name` varchar(240) NULL COMMENT \"  \",\n  `zone_code` char(10) NULL COMMENT \"   (有且必须只能  位)\",\n  `zone_name` char(20) NULL COMMENT \"  \",\n  `brand_unit_no` char(18) NULL COMMENT \"  \",\n  `brand_unit_name` varchar(50) NULL COMMENT \"  \",\n  `years` varchar(20) NULL COMMENT \"   (指上  份,下拉框选择,值: 2006~2026,默认当年)\",\n  `region_no` char(18) NULL COMMENT \"  \",\n  `region_name` varchar(50) NULL COMMENT \"  \",\n  `remark` varchar(255) NULL COMMENT \"  \",\n  `item_style_no` varchar(20) NULL COMMENT \"    育)\",\n  `item_series_no` varchar(20) NULL COMMENT \"    育)\",\n  `style_series_name` varchar(50) NULL COMMENT \"  \",\n  `management_area_no` varchar(18) NULL COMMENT \"  \",\n  `management_area_name` varchar(32) NULL COMMENT \"  \",\n  `express_no` varchar(36) NULL COMMENT \"  \",\n  `logistics_no` varchar(18) NULL COMMENT \"  \",\n  `logistics_name` varchar(200) NULL COMMENT \"  \",\n  `pickup_date` date NULL COMMENT \"  \",\n  `check_user_no` varchar(20) NULL COMMENT \"  \",\n  `check_user` varchar(32) NULL COMMENT \"  \",\n  `message_code` varchar(32) NULL COMMENT \"  \",\n  `order_taking` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `order_taking_time` datetime NULL COMMENT \"  \",\n  `express_inbound_time` datetime NULL COMMENT \"  \",\n  `item_flag_new` varchar(20) NULL COMMENT \"   ,商品、赠  料\",\n  `inventory_nearby_reason` varchar(255) NULL COMMENT \"  \",\n  `order_refuse_reason` varchar(255) NULL COMMENT \"  \",\n  `order_refuse_shop_name` varchar(100) NULL COMMENT \"  \",\n  `order_refuse_time` datetime NULL COMMENT \"  \",\n  `change_shop_no_from_time` datetime NULL COMMENT \"  \",\n  `station_id` varchar(100) NULL COMMENT \"  \",\n  `station_name` varchar(100) NULL COMMENT \"  \",\n  `express_sign_time` datetime NULL COMMENT \"  \",\n  `from_type` tinyint(4) NULL DEFAULT \"1\" COMMENT \"   1-店铺 2-仓库 3-工厂\",\n  `dest_code` char(8) NULL COMMENT \"  \",\n  `plate_code` varchar(40) NULL COMMENT \"  \",\n  `manual_change_shop` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `order_refuse_count` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `service_type_no` char(18) NULL COMMENT \"  \",\n  `service_type_name` varchar(20) NULL COMMENT \"  \",\n  `company_no_from` char(18) NULL COMMENT \"  \",\n  `company_name_from` varchar(200) NULL COMMENT \"  \",\n  `grab_order` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `inventory_status` char(2) NULL DEFAULT \"0\" COMMENT \"     1-有货2-断码3-断货\",\n  `flyshoe_flag` tinyint(4) NULL DEFAULT \"1\" COMMENT \"   -非  2-飞鞋\",\n  `province_no` varchar(20) NULL COMMENT \"  \",\n  `province_name` varchar(60) NULL COMMENT \"  \",\n  `customer_settle_price` decimal128(20, 2) NULL COMMENT \"  \",\n  `member_property` int(11) NULL DEFAULT \"-1\" COMMENT \"  \",\n  `virtual_activityFlag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `employee_card_pref_price` decimal128(20, 2) NULL COMMENT \"  \",\n  `is_buy_out` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0,不是;1,是;\",\n  `use_amount_limit` decimal128(20, 2) NULL COMMENT \"  \",\n  `third_ticket_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `contract_discount` decimal64(10, 2) NULL COMMENT \"  \",\n  `customed_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `customed_group_num` int(11) NULL COMMENT \"  \",\n  `yougou_order_dtl_id` varchar(32) NULL COMMENT \"  \",\n  `supply_price` decimal128(20, 2) NULL COMMENT \"  \"\n) ENGINE=OLAP \nPRIMARY KEY(`order_no`, `id`, `out_date`)\nCOMMENT \"  \"\nPARTITION BY RANGE(`out_date`)\n(PARTITION p202304 VALUES [(\"2023-04-01\"), (\"2023-05-01\")),\nPARTITION p202305 VALUES [(\"2023-05-01\"), (\"2023-06-01\")))\nDISTRIBUTED BY HASH(`order_no`) BUCKETS 4 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"bloom_filter_columns\" = \"sku_no, item_no, shop_no\",\n\"dynamic_partition.enable\" = \"true\",\n\"dynamic_partition.time_unit\" = \"month\",\n\"dynamic_partition.time_zone\" = \"Asia/Shanghai\",\n\"dynamic_partition.start\" = \"-2147483648\",\n\"dynamic_partition.end\" = \"1\",\n\"dynamic_partition.prefix\" = \"p\",\n\"dynamic_partition.buckets\" = \"4\",\n\"dynamic_partition.history_partition_num\" = \"0\",\n\"dynamic_partition.start_day_of_month\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"true\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);",
    "retail_pos.order_main": "CREATE TABLE `order_main` (\n  `order_no` varchar(25) NOT NULL COMMENT \"  \",\n  `out_date` date NOT NULL COMMENT \"  \",\n  `id` char(32) NULL COMMENT \"    键\",\n  `company_no` char(18) NULL COMMENT \"  \",\n  `company_name` varchar(200) NULL COMMENT \"  \",\n  `ref_bill_no` char(30) NULL COMMENT \"  \",\n  `shop_no` char(18) NULL COMMENT \"  \",\n  `shop_name` varchar(100) NULL COMMENT \"  \",\n  `shop_no_from` char(18) NULL COMMENT \"  \",\n  `shop_name_from` varchar(100) NULL COMMENT \"   -  称\",\n  `serial_no` char(32) NULL COMMENT \"  \",\n  `qty` int(11) NULL COMMENT \"  \",\n  `tag_price_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `sale_price_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `disc_price_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `settle_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `reduce_amount` decimal128(20, 2) NULL COMMENT \"   ,(单  价*数量)之和\",\n  `total_rebate_amount` decimal128(20, 2) NULL COMMENT \"   \",\n  `pref_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `coupon_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `all_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `remain_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `score_amount` decimal128(20, 2) NULL DEFAULT \"0.00\" COMMENT \"  \",\n  `assistant_name` varchar(330) NULL COMMENT \"  \",\n  `assistant_id` varchar(330) NULL COMMENT \"  \",\n  `assistant_no` varchar(210) NULL COMMENT \"  \",\n  `vip_no` varchar(128) NULL COMMENT \"  \",\n  `vip_brand_no` char(18) NULL COMMENT \"  \",\n  `vip_name` varchar(128) NULL COMMENT \"  \",\n  `vip_phone` varchar(64) NULL COMMENT \"  \",\n  `wildcard_no` varchar(20) NULL COMMENT \"  \",\n  `wildcard_name` varchar(50) NULL COMMENT \"  \",\n  `wildcard_discount` decimal64(10, 4) NULL COMMENT \"  \",\n  `base_score` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `pro_score` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `cost_score` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `order_type` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `business_type` tinyint(4) NULL COMMENT \"  \",\n  `biz_type_code` varchar(10) NULL COMMENT \"  \",\n  `biz_type_name` varchar(30) NULL COMMENT \"  \",\n  `order_source` tinyint(4) NULL DEFAULT \"1\" COMMENT \"  \",\n  `daily_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-未日结 1-已日结 默认为0\",\n  `daily_datetime` datetime NULL COMMENT \"  \",\n  `monthly_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `monthly_datetime` datetime NULL COMMENT \"  \",\n  `balance_no` char(20) NULL COMMENT \"  \",\n  `remark` varchar(255) NULL COMMENT \"  \",\n  `random_code` varchar(4) NULL COMMENT \"  \",\n  `red_invoice_code` varchar(30) NULL COMMENT \"   +  码\",\n  `blue_invoice_code` varchar(30) NULL COMMENT \"   +  码\",\n  `status` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `actual_postage` decimal128(20, 2) NULL COMMENT \"  \",\n  `message_code` varchar(32) NULL COMMENT \"  \",\n  `express_company` varchar(50) NULL COMMENT \"  \",\n  `bill_transfer_no` varchar(255) NULL COMMENT \"  \",\n  `express_no` varchar(36) NULL COMMENT \"  \",\n  `logistics_no` varchar(18) NULL COMMENT \"  \",\n  `take_mode` tinyint(4) NULL COMMENT \"   0-本店自提 1-邻店自提\",\n  `logistics_mode` tinyint(4) NULL COMMENT \"   1-自提 2-快递 3-现提\",\n  `market_ticket_no` varchar(100) NULL COMMENT \"  \",\n  `lock_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-未锁单 1-已锁单\",\n  `return_exchange_time` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `shop_terminal_no` varchar(20) NULL COMMENT \"  \",\n  `invoice_apply_no` char(18) NULL COMMENT \"   ,类型为团  值\",\n  `invoice_apply_date` datetime NULL COMMENT \"   ,类型为团  值\",\n  `invoice_no` varchar(32) NULL COMMENT \"  \",\n  `invoice_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `invoice_date` date NULL COMMENT \"  \",\n  `pickup_date` date NULL COMMENT \"  \",\n  `zone_yyyymm` char(8) NULL COMMENT \"  \",\n  `check_user_no` varchar(20) NULL COMMENT \"  \",\n  `check_user` varchar(32) NULL COMMENT \"  \",\n  `create_user_no` varchar(20) NULL COMMENT \"  \",\n  `create_user` varchar(32) NULL COMMENT \"  \",\n  `create_time` datetime NULL COMMENT \"   ,  建\",\n  `update_user_no` varchar(20) NULL COMMENT \"  \",\n  `update_user` varchar(32) NULL COMMENT \"  \",\n  `update_time` datetime NULL COMMENT \"  \",\n  `adjust_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `adjust_user` varchar(32) NULL COMMENT \"  \",\n  `adjust_time` datetime NULL COMMENT \"  \",\n  `adjust_order_reason` varchar(255) NULL COMMENT \"  \",\n  `reason_class_name` varchar(100) NULL COMMENT \"  \",\n  `reason_class_no` varchar(10) NULL COMMENT \"  \",\n  `reason_code` varchar(50) NULL COMMENT \"  \",\n  `responsibility_name` varchar(330) NULL COMMENT \"  \",\n  `responsibility_no` varchar(210) NULL COMMENT \"  \",\n  `responsibility_id` varchar(330) NULL COMMENT \"  \",\n  `sharding_flag` varchar(20) NULL COMMENT \"  \",\n  `remain_score` int(11) NULL COMMENT \"  \",\n  `accumulated_score` int(11) NULL COMMENT \"  \",\n  `notice_user` varchar(32) NULL COMMENT \"  \",\n  `notice_time` datetime NULL COMMENT \"  \",\n  `notice_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-未通知 1-通知\",\n  `pay_time` datetime NULL COMMENT \"  \",\n  `lasted_delivery_time` datetime NULL COMMENT \"  \",\n  `refund_status` tinyint(4) NULL DEFAULT \"30\" COMMENT \"      款 20 退款成功 默认30\",\n  `place_date` date NULL COMMENT \"  \",\n  `reprint` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `adjust_inventory_flag` tinyint(4) NULL DEFAULT \"1\" COMMENT \"  \",\n  `platform_no` char(30) NULL COMMENT \"  \",\n  `platform_name` char(30) NULL COMMENT \"  \",\n  `delivery_time` datetime NULL COMMENT \"  \",\n  `delivery_date` date NULL COMMENT \"  \",\n  `invoice_type` tinyint(4) NULL COMMENT \"   1:普通发票 3:不需要发票(O2O)\",\n  `invoice_unit` varchar(60) NULL COMMENT \"     O)\",\n  `invoice_content` varchar(255) NULL COMMENT \"     O)\",\n  `is_package_mail_flag` tinyint(4) NULL COMMENT \"   0-正常 1-不包邮 2-包邮\",\n  `member_id` varchar(32) NULL COMMENT \"  \",\n  `out_time` datetime NULL COMMENT \"  \",\n  `client_no` char(18) NULL COMMENT \"  \",\n  `client_name` varchar(100) NULL COMMENT \"  \",\n  `dispatch_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-否 1-是\",\n  `sync_isp_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-否 1-是 2-无需同步\",\n  `card_no_bg` varchar(50) NULL COMMENT \"  \",\n  `return_in_source` char(4) NULL DEFAULT \"1\" COMMENT \"    常 2-预售 \",\n  `order_refuse_count` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `customer_settle_price_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `employee_card_no` varchar(30) NULL COMMENT \"  \",\n  `employee_card_pref_price_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `po_no` varchar(25) NULL COMMENT \"  \",\n  `order_schedule` varchar(10) NULL COMMENT \"  \",\n  `topmall_no` char(18) NULL COMMENT \"  \",\n  `verification_code` varchar(10) NULL COMMENT \"  \",\n  `face_id` varchar(25) NULL COMMENT \"  \",\n  `third_ticket_all_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `employee_child_card_no` varchar(30) NULL COMMENT \"  \",\n  `system_source` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `employee_card_code` varchar(30) NULL COMMENT \"  \",\n  `employee_card_type` varchar(30) NULL COMMENT \"  \",\n  `delivery_mode` tinyint(4) NULL COMMENT \"     发;2仓发\",\n  `guide_order_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  ; 0=>否;1=>是\",\n  `vip_pref_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `return_type` varchar(10) NULL COMMENT \"  \",\n  `headless_order_no` varchar(30) NULL COMMENT \"  \",\n  `fetch_code` varchar(16) NULL COMMENT \"   -  评\",\n  `mall_score_flag` tinyint(4) NULL COMMENT \"  \",\n  `custom_sign` tinyint(4) NULL COMMENT \"   \",\n  `batch_no` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `group_buy_code` varchar(15) NULL DEFAULT \"0\" COMMENT \"   0:不参与促;非0-促销活动验证码\",\n  `special_code` varchar(15) NULL COMMENT \"  \",\n  `sub_order_type` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   >普通订单，1=>京东自提，默认是0\",\n  `private_sale` char(10) NULL DEFAULT \"0\" COMMENT \"     域,1-OS26不结算,2-OS11结算,3-OS24不结算\",\n  `sales_performance_shop_no` char(18) NULL COMMENT \"  \",\n  `sales_performance_shop_name` varchar(100) NULL COMMENT \"  \",\n  `exchange_curr_code` varchar(18) NULL COMMENT \"  \",\n  `exchange_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `bookkeeping_third_flag` varchar(50) NULL COMMENT \"  \",\n  `virtual_store_no` varchar(32) NULL COMMENT \"  \"\n) ENGINE=OLAP \nPRIMARY KEY(`order_no`, `out_date`)\nCOMMENT \"  \"\nPARTITION BY RANGE(`out_date`)\n(PARTITION p202304 VALUES [(\"2023-04-01\"), (\"2023-05-01\")),\nPARTITION p202305 VALUES [(\"2023-05-01\"), (\"2023-06-01\")))\nDISTRIBUTED BY HASH(`order_no`) BUCKETS 8 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"bloom_filter_columns\" = \"shop_no\",\n\"dynamic_partition.enable\" = \"true\",\n\"dynamic_partition.time_unit\" = \"month\",\n\"dynamic_partition.time_zone\" = \"Asia/Shanghai\",\n\"dynamic_partition.start\" = \"-2147483648\",\n\"dynamic_partition.end\" = \"1\",\n\"dynamic_partition.prefix\" = \"p\",\n\"dynamic_partition.buckets\" = \"8\",\n\"dynamic_partition.history_partition_num\" = \"0\",\n\"dynamic_partition.start_day_of_month\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"true\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);",
    "retail_pos.order_unit": "CREATE TABLE `order_unit` (\n  `order_unit_no` varchar(18) NOT NULL COMMENT \"  \",\n  `id` int(11) NULL COMMENT \"  \",\n  `order_unit_code` varchar(10) NULL COMMENT \"  \",\n  `organ_no` char(18) NULL COMMENT \"  \",\n  `name` varchar(240) NULL COMMENT \"  \",\n  `company_no` char(18) NULL COMMENT \"  \",\n  `status` tinyint(4) NULL DEFAULT \"1\" COMMENT \"  \",\n  `create_user` varchar(32) NULL COMMENT \"  \",\n  `create_time` datetime NULL COMMENT \"  \",\n  `update_user` varchar(32) NULL COMMENT \"  \",\n  `update_time` datetime NULL COMMENT \"  \",\n  `remark` varchar(255) NULL DEFAULT \"\" COMMENT \"  \",\n  `time_seq` bigint(20) NULL COMMENT \"  \",\n  `search_code` varchar(10) NULL COMMENT \"  \",\n  `type` tinyint(4) NULL COMMENT \"   (oth_sys_  e.code_no=U1201)\",\n  `organ_type_no` varchar(50) NULL COMMENT \"  \",\n  `order_no` int(11) NULL COMMENT \"  \",\n  `map_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0:否,1:是)\"\n) ENGINE=OLAP \nPRIMARY KEY(`order_unit_no`)\nCOMMENT \"   (ot  表-来源mdm)\"\nDISTRIBUTED BY HASH(`order_unit_no`) BUCKETS 4 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"true\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);",
    "retail_pos.organ": "CREATE TABLE `organ` (\n  `organ_no` varchar(18) NOT NULL COMMENT \"  \",\n  `parent_no` varchar(18) NOT NULL COMMENT \"  \",\n  `id` int(11) NULL COMMENT \"  \",\n  `organ_code` varchar(20) NULL COMMENT \"  \",\n  `name` varchar(240) NULL COMMENT \"  \",\n  `nc_business_city_no` varchar(30) NULL COMMENT \"  \",\n  `nc_managing_city_no` varchar(30) NULL COMMENT \"  \",\n  `status` tinyint(4) NULL DEFAULT \"1\" COMMENT \"  \",\n  `organ_level` int(11) NULL COMMENT \"   1 管理城市,2 经营城市\",\n  `order_no` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `path` varchar(200) NULL COMMENT \"  \",\n  `zone_no` char(18) NULL COMMENT \"  \",\n  `create_user` varchar(32) NULL COMMENT \"  \",\n  `create_time` datetime NULL COMMENT \"  \",\n  `update_user` varchar(32) NULL COMMENT \"  \",\n  `update_time` datetime NULL COMMENT \"  \",\n  `remark` varchar(255) NULL DEFAULT \"\" COMMENT \"  \",\n  `time_seq` bigint(20) NULL COMMENT \"  \",\n  `organ_type_no` varchar(50) NULL COMMENT \"  \",\n  `subarea_no` char(18) NULL COMMENT \"  \"\n) ENGINE=OLAP \nPRIMARY KEY(`organ_no`, `parent_no`)\nCOMMENT \"   (  市/经营城市)表(otter表-来源mdm)\"\nDISTRIBUTED BY HASH(`organ_no`) BUCKETS 4 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"true\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);",
    "retail_pos.return_exchange_dtl": "CREATE TABLE `return_exchange_dtl` (\n  `business_no` varchar(25) NOT NULL COMMENT \"  \",\n  `id` varchar(32) NOT NULL COMMENT \"   ,uu  成\",\n  `out_date` date NOT NULL COMMENT \"  \",\n  `ref_bill_no` char(30) NULL COMMENT \"  \",\n  `shop_no` char(18) NULL COMMENT \"  \",\n  `shop_name` varchar(100) NULL COMMENT \"  \",\n  `shop_no_from` char(18) NULL COMMENT \"    货)门店编码\",\n  `shop_name_from` varchar(100) NULL COMMENT \"    货)门店\",\n  `sku_no` char(32) NULL COMMENT \"  \",\n  `item_no` varchar(20) NULL COMMENT \"  \",\n  `size_no` varchar(10) NULL COMMENT \"  \",\n  `item_code` varchar(30) NULL COMMENT \"  \",\n  `item_name` varchar(200) NULL COMMENT \"  \",\n  `barcode` varchar(50) NULL COMMENT \"  \",\n  `brand_no` char(18) NULL COMMENT \"  \",\n  `item_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-正常 1-赠品 促销标识\",\n  `tag_price` decimal128(20, 2) NULL COMMENT \"  \",\n  `sale_price` decimal128(20, 2) NULL COMMENT \"  \",\n  `disc_price` decimal128(20, 2) NULL COMMENT \"  \",\n  `settle_price` decimal128(20, 2) NULL COMMENT \"  \",\n  `reduce_price` decimal128(20, 2) NULL COMMENT \"   ,  价\",\n  `rebate_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `score_amount` decimal128(20, 2) NULL DEFAULT \"0.00\" COMMENT \"  \",\n  `qty` int(11) NULL COMMENT \"  \",\n  `amount` decimal128(20, 2) NULL COMMENT \"   ,  价-减价)*数量\",\n  `pref_price` decimal128(20, 2) NULL COMMENT \"   ,促销  价\",\n  `pro_no` varchar(130) NULL COMMENT \"  \",\n  `pro_name` varchar(310) NULL COMMENT \"  \",\n  `special_sell_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-正常 1-特卖\",\n  `discount` decimal64(10, 4) NULL COMMENT \"     7.00代表17.00%\",\n  `discount_code` varchar(10) NULL COMMENT \"   B\",\n  `discount_name` varchar(100) NULL COMMENT \"  \",\n  `discount_type` tinyint(4) NULL COMMENT \"  \",\n  `discount_type_name` varchar(50) NULL COMMENT \"  \",\n  `discount_source_id` varchar(36) NULL COMMENT \"  \",\n  `billing_code` varchar(32) NULL COMMENT \"  \",\n  `properties` tinyint(4) NULL COMMENT \"   1-满送 2-满减 3-折扣 4-其他 5-买当\",\n  `virtual_flag` tinyint(4) NULL COMMENT \"   0-虚数 1-实数\",\n  `strength` decimal64(8, 2) NULL COMMENT \"  \",\n  `activity_type_name` varchar(100) NULL COMMENT \"  \",\n  `activity_type` tinyint(4) NULL COMMENT \"  \",\n  `launch_type_name` varchar(100) NULL COMMENT \"  \",\n  `launch_type` tinyint(4) NULL COMMENT \"   1-商场发起 2-品牌公司发起\",\n  `pro_end_time` datetime NULL COMMENT \"  \",\n  `pro_start_time` datetime NULL COMMENT \"  \",\n  `balance_base` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-销售金额 1-牌价金额\",\n  `vip_discount` decimal64(10, 4) NULL COMMENT \"  \",\n  `vip_level_name` varchar(64) NULL COMMENT \"  \",\n  `vip_level_code` varchar(10) NULL COMMENT \"  \",\n  `base_score` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `pro_score` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `cost_score` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `available_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-可二次销售 1-不可二次销售\",\n  `item_discount` decimal64(10, 4) NULL COMMENT \"  \",\n  `reason` varchar(255) NULL COMMENT \"  \",\n  `reason_class_name` varchar(100) NULL COMMENT \"  \",\n  `reason_class_no` varchar(10) NULL COMMENT \"  \",\n  `reason_code` varchar(50) NULL COMMENT \"  \",\n  `order_dtl_id` varchar(36) NULL COMMENT \"  \",\n  `color_no` varchar(18) NULL COMMENT \"  \",\n  `color_name` varchar(50) NULL COMMENT \"  \",\n  `brand_name` varchar(200) NULL COMMENT \"  \",\n  `size_kind` char(2) NULL COMMENT \"  \",\n  `category_no` char(18) NULL COMMENT \"  \",\n  `return_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-未退 1-已退 默认为0-未退\",\n  `bill_transfer_no` varchar(36) NULL COMMENT \"   ,只有跨店销售（本店自提）  据\",\n  `price_change_bill_no` varchar(40) NULL COMMENT \"  \",\n  `return_exchange_num` smallint(6) NULL DEFAULT \"0\" COMMENT \"   (只有换货  有)\",\n  `zone_yyyymm` char(8) NULL COMMENT \"  \",\n  `specified_discount_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   \",\n  `pickup_status` tinyint(4) NULL DEFAULT \"1\" COMMENT \"  \",\n  `take_off_type` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `pickup_user` varchar(32) NULL COMMENT \"  \",\n  `pickup_user_no` varchar(20) NULL COMMENT \"  \",\n  `pickup_time` datetime NULL COMMENT \"   -收银出库时  客-提货时间\",\n  `invoice_no` varchar(255) NULL COMMENT \"     S),多个用逗号(,)分隔\",\n  `actual_amount` decimal128(20, 2) NULL DEFAULT \"0.00\" COMMENT \"   (优  值+结算金额)\",\n  `real_buy_amount` decimal128(20, 2) NULL DEFAULT \"0.00\" COMMENT \"   (优惠券  额)\",\n  `surplus_amount` decimal128(20, 2) NULL DEFAULT \"0.00\" COMMENT \"   (优  值)\",\n  `rate_discount` decimal128(20, 4) NULL DEFAULT \"0.0000\" COMMENT \"  \",\n  `create_user` varchar(32) NULL COMMENT \"  \",\n  `create_time` datetime NULL COMMENT \"  \",\n  `update_user` varchar(32) NULL COMMENT \"  \",\n  `update_time` datetime NULL COMMENT \"  \",\n  `sharding_flag` varchar(20) NULL COMMENT \"  \",\n  `style_no` varchar(30) NULL COMMENT \"  \",\n  `change_state` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `change_audit_state` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `change_state_audit_user` varchar(32) NULL COMMENT \"  \",\n  `change_state_audit_time` datetime NULL COMMENT \"  \",\n  `rate_pro_no` varchar(130) NULL COMMENT \"  \",\n  `rate_pro_name` varchar(130) NULL COMMENT \"  \",\n  `biz_city_no` char(18) NULL COMMENT \"  \",\n  `biz_city_name` varchar(240) NULL COMMENT \"  \",\n  `organ_no` char(18) NULL COMMENT \"  \",\n  `organ_name` varchar(240) NULL COMMENT \"  \",\n  `zone_code` char(10) NULL COMMENT \"   (有且必须只能  位)\",\n  `zone_name` char(20) NULL COMMENT \"  \",\n  `brand_unit_no` char(18) NULL COMMENT \"  \",\n  `brand_unit_name` varchar(50) NULL COMMENT \"  \",\n  `years` varchar(20) NULL COMMENT \"   (指上  份,下拉框选择,值: 2006~2026,默认当年)\",\n  `region_no` char(18) NULL COMMENT \"  \",\n  `region_name` varchar(50) NULL COMMENT \"  \",\n  `remark` varchar(255) NULL COMMENT \"  \",\n  `item_style_no` varchar(20) NULL COMMENT \"    育)\",\n  `item_series_no` varchar(20) NULL COMMENT \"    育)\",\n  `style_series_name` varchar(50) NULL COMMENT \"  \",\n  `management_area_no` varchar(18) NULL COMMENT \"  \",\n  `management_area_name` varchar(32) NULL COMMENT \"  \",\n  `order_taking` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-正常 1-已接，2-未接,3-拒绝接单,4-待派单\",\n  `express_no` varchar(36) NULL COMMENT \"  \",\n  `logistics_no` varchar(18) NULL COMMENT \"  \",\n  `logistics_name` varchar(200) NULL COMMENT \"  \",\n  `check_user_no` varchar(20) NULL COMMENT \"  \",\n  `check_user` varchar(32) NULL COMMENT \"  \",\n  `order_taking_time` datetime NULL COMMENT \"  \",\n  `express_inbound_time` datetime NULL COMMENT \"  \",\n  `item_flag_new` varchar(20) NULL COMMENT \"   ,商品、赠  料\",\n  `inventory_nearby_reason` varchar(255) NULL COMMENT \"  \",\n  `order_refuse_reason` varchar(255) NULL COMMENT \"  \",\n  `order_refuse_shop_name` varchar(100) NULL COMMENT \"  \",\n  `order_refuse_time` datetime NULL COMMENT \"  \",\n  `change_shop_no_from_time` datetime NULL COMMENT \"  \",\n  `station_id` varchar(100) NULL COMMENT \"  \",\n  `station_name` varchar(100) NULL COMMENT \"  \",\n  `express_sign_time` datetime NULL COMMENT \"  \",\n  `plate_code` varchar(40) NULL COMMENT \"  \",\n  `service_type_no` char(18) NULL COMMENT \"  \",\n  `service_type_name` varchar(20) NULL COMMENT \"  \",\n  `company_no_from` char(18) NULL COMMENT \"  \",\n  `company_name_from` varchar(200) NULL COMMENT \"  \",\n  `across_sale_flag` tinyint(4) NULL DEFAULT \"1\" COMMENT \"   0-否 1-是\",\n  `return_audit_state` tinyint(4) NULL COMMENT \"   0-正常,1-已审核,2-未审核\",\n  `return_auditor` varchar(32) NULL COMMENT \"  \",\n  `return_audit_time` datetime NULL COMMENT \"  \",\n  `province_no` varchar(20) NULL COMMENT \"  \",\n  `province_name` varchar(60) NULL COMMENT \"  \",\n  `customer_settle_price` decimal128(20, 2) NULL COMMENT \"  \",\n  `member_property` int(11) NULL DEFAULT \"-1\" COMMENT \"  \",\n  `virtual_activityFlag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `employee_card_pref_price` decimal128(20, 2) NULL COMMENT \"  \",\n  `is_buy_out` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0,不是;1,是;\",\n  `use_amount_limit` decimal128(20, 2) NULL COMMENT \"  \",\n  `third_ticket_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `contract_discount` decimal64(10, 2) NULL COMMENT \"  \",\n  `customed_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `customed_group_num` int(11) NULL COMMENT \"  \",\n  `cash_real_buy_amount` decimal128(20, 2) NULL COMMENT \"   -券实收金  额\",\n  `cash_surplus_amount` decimal128(20, 2) NULL COMMENT \"   -  额\",\n  `yougou_order_dtl_id` varchar(32) NULL COMMENT \"  \",\n  `extend_item_no` varchar(32) NULL COMMENT \"   -  号\",\n  `extend_barcode` varchar(32) NULL COMMENT \"   -  码\",\n  `supply_price` decimal128(20, 2) NULL COMMENT \"  \"\n) ENGINE=OLAP \nPRIMARY KEY(`business_no`, `id`, `out_date`)\nCOMMENT \"  \"\nPARTITION BY RANGE(`out_date`)\n(PARTITION p202304 VALUES [(\"2023-04-01\"), (\"2023-05-01\")),\nPARTITION p202305 VALUES [(\"2023-05-01\"), (\"2023-06-01\")))\nDISTRIBUTED BY HASH(`business_no`) BUCKETS 8 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"bloom_filter_columns\" = \"sku_no, item_no, shop_no\",\n\"dynamic_partition.enable\" = \"true\",\n\"dynamic_partition.time_unit\" = \"month\",\n\"dynamic_partition.time_zone\" = \"Asia/Shanghai\",\n\"dynamic_partition.start\" = \"-2147483648\",\n\"dynamic_partition.end\" = \"1\",\n\"dynamic_partition.prefix\" = \"p\",\n\"dynamic_partition.buckets\" = \"8\",\n\"dynamic_partition.history_partition_num\" = \"0\",\n\"dynamic_partition.start_day_of_month\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"true\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);",
    "retail_pos.return_exchange_main": "CREATE TABLE `return_exchange_main` (\n  `business_no` varchar(25) NOT NULL COMMENT \"   ,  号\",\n  `out_date` date NOT NULL COMMENT \"  \",\n  `id` char(32) NULL COMMENT \"    键\",\n  `company_no` char(18) NULL COMMENT \"  \",\n  `company_name` varchar(200) NULL COMMENT \"  \",\n  `ref_bill_no` char(30) NULL COMMENT \"  \",\n  `shop_no` char(18) NULL COMMENT \"  \",\n  `shop_name` varchar(100) NULL COMMENT \"  \",\n  `old_out_date` date NULL COMMENT \"  \",\n  `qty` int(11) NULL COMMENT \"  \",\n  `tag_price_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `sale_price_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `disc_price_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `settle_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `reduce_amount` decimal128(20, 2) NULL COMMENT \"   ,(单  价*数量)之和\",\n  `total_rebate_amount` decimal128(20, 2) NULL COMMENT \"   \",\n  `pref_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `coupon_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `all_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `amount` decimal128(20, 2) NULL COMMENT \"   ,订单应  额+优惠券总金额+找零金额\",\n  `remain_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `score_amount` decimal128(20, 2) NULL DEFAULT \"0.00\" COMMENT \"  \",\n  `assistant_name` varchar(330) NULL COMMENT \"   ,营业员姓名，多个营业员使用  开\",\n  `assistant_id` varchar(330) NULL COMMENT \"  \",\n  `assistant_no` varchar(210) NULL COMMENT \"  \",\n  `vip_no` varchar(128) NULL COMMENT \"  \",\n  `vip_brand_no` char(18) NULL COMMENT \"  \",\n  `vip_name` varchar(128) NULL COMMENT \"  \",\n  `vip_phone` varchar(64) NULL COMMENT \"  \",\n  `wildcard_no` varchar(20) NULL COMMENT \"  \",\n  `wildcard_name` varchar(50) NULL COMMENT \"  \",\n  `wildcard_discount` decimal64(10, 4) NULL COMMENT \"  \",\n  `base_score` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `pro_score` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `cost_score` int(11) NULL DEFAULT \"0\" COMMENT \"  \",\n  `business_mode` tinyint(4) NULL DEFAULT \"2\" COMMENT \"   1-换货 2-退货 默认为2\",\n  `random_code` varchar(4) NULL COMMENT \"  \",\n  `red_invoice_code` varchar(30) NULL COMMENT \"   +  码\",\n  `return_audit_state` tinyint(4) NULL DEFAULT \"2\" COMMENT \"   0-正常,1-已审核,2-未审核 3-审核退回\",\n  `return_auditor` varchar(32) NULL COMMENT \"  \",\n  `return_audit_time` datetime NULL COMMENT \"  \",\n  `return_audit_refuse_reason` varchar(150) NULL COMMENT \"  \",\n  `business_type` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   ,取原订单的  型\",\n  `order_source` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `daily_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-未日结 1-已日结 默认为0\",\n  `daily_datetime` datetime NULL COMMENT \"  \",\n  `balance_no` char(20) NULL COMMENT \"  \",\n  `monthly_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-未月结 1-已月结 默认为0\",\n  `monthly_datetime` datetime NULL COMMENT \"  \",\n  `old_order_no` varchar(25) NULL COMMENT \"  \",\n  `new_order_no` varchar(36) NULL COMMENT \"    货)\",\n  `remark` varchar(255) NULL COMMENT \"  \",\n  `status` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `actual_postage` decimal128(20, 2) NULL COMMENT \"  \",\n  `express_no` varchar(36) NULL COMMENT \"  \",\n  `logistics_no` varchar(18) NULL COMMENT \"  \",\n  `take_mode` tinyint(4) NULL COMMENT \"   0-自提 1-快递\",\n  `market_ticket_no` varchar(100) NULL COMMENT \"  \",\n  `lock_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-未锁单 1-已锁单\",\n  `return_exchange_time` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   ,只有换货  有\",\n  `shop_terminal_no` varchar(20) NULL COMMENT \"  \",\n  `invoice_no` varchar(32) NULL COMMENT \"  \",\n  `invoice_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `invoice_date` date NULL COMMENT \"  \",\n  `zone_yyyymm` char(8) NULL COMMENT \"  \",\n  `create_user_no` varchar(20) NULL COMMENT \"  \",\n  `create_user` varchar(32) NULL COMMENT \"  \",\n  `create_time` datetime NULL COMMENT \"  \",\n  `update_user_no` varchar(20) NULL COMMENT \"  \",\n  `update_user` varchar(32) NULL COMMENT \"  \",\n  `update_time` datetime NULL COMMENT \"  \",\n  `adjust_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `adjust_user` varchar(32) NULL COMMENT \"  \",\n  `adjust_time` datetime NULL COMMENT \"  \",\n  `adjust_order_reason` varchar(255) NULL COMMENT \"  \",\n  `reason_class_name` varchar(100) NULL COMMENT \"  \",\n  `reason_class_no` varchar(10) NULL COMMENT \"  \",\n  `reason_code` varchar(50) NULL COMMENT \"  \",\n  `responsibility_name` varchar(330) NULL COMMENT \"  \",\n  `responsibility_no` varchar(210) NULL COMMENT \"  \",\n  `responsibility_id` varchar(330) NULL COMMENT \"  \",\n  `sharding_flag` varchar(20) NULL COMMENT \"  \",\n  `remain_score` int(11) NULL COMMENT \"  \",\n  `accumulated_score` int(11) NULL COMMENT \"  \",\n  `pay_time` datetime NULL COMMENT \"  \",\n  `place_date` date NULL COMMENT \"  \",\n  `refund_type` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0-正常 1-退款\",\n  `refund_status` tinyint(4) NULL DEFAULT \"30\" COMMENT \"      款 20 退款成功 默认30\",\n  `reprint` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `adjust_inventory_flag` tinyint(4) NULL DEFAULT \"1\" COMMENT \"  \",\n  `platform_no` char(30) NULL COMMENT \"  \",\n  `platform_name` char(30) NULL COMMENT \"  \",\n  `delivery_time` datetime NULL COMMENT \"  \",\n  `delivery_date` date NULL COMMENT \"  \",\n  `invoice_type` tinyint(4) NULL COMMENT \"   1:普通发票 3:不需要发票(O2O)\",\n  `invoice_unit` varchar(60) NULL COMMENT \"     O)\",\n  `invoice_content` varchar(255) NULL COMMENT \"     O)\",\n  `is_package_mail_flag` tinyint(4) NULL COMMENT \"   0-正常 1-不包邮 2-包邮\",\n  `member_id` varchar(32) NULL COMMENT \"  \",\n  `out_time` datetime NULL COMMENT \"  \",\n  `biz_type_code` varchar(10) NULL COMMENT \"  \",\n  `biz_type_name` varchar(30) NULL COMMENT \"  \",\n  `client_no` char(18) NULL COMMENT \"  \",\n  `client_name` varchar(100) NULL COMMENT \"  \",\n  `card_no_bg` varchar(50) NULL COMMENT \"  \",\n  `return_in_source` char(4) NULL DEFAULT \"1\" COMMENT \"    常 2-预售 3-优购预售\",\n  `customer_settle_price_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `employee_card_no` varchar(30) NULL COMMENT \"  \",\n  `employee_card_pref_price_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `topmall_no` char(18) NULL COMMENT \"  \",\n  `order_schedule` varchar(10) NULL COMMENT \"  \",\n  `verification_code` varchar(10) NULL COMMENT \"  \",\n  `face_id` varchar(25) NULL COMMENT \"  \",\n  `third_ticket_all_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `employee_child_card_no` varchar(30) NULL COMMENT \"  \",\n  `system_source` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `employee_card_code` varchar(30) NULL COMMENT \"  \",\n  `employee_card_type` varchar(30) NULL COMMENT \"  \",\n  `guide_order_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  ; 0=>否;1=>是\",\n  `quality_checking_date` date NULL COMMENT \"  \",\n  `vip_pref_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `return_type` varchar(10) NULL COMMENT \"  \",\n  `headless_order_no` varchar(30) NULL COMMENT \"  \",\n  `serial_no` varchar(32) NULL COMMENT \"  \",\n  `mall_score_flag` tinyint(4) NULL COMMENT \"  \",\n  `batch_no` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `special_code` varchar(15) NULL COMMENT \"  \",\n  `custom_sign` tinyint(4) NULL DEFAULT \"0\" COMMENT \"  \",\n  `po_no` varchar(25) NULL COMMENT \"  \",\n  `sub_order_type` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   >普通订单，1=>京东自提，默认是0\",\n  `private_sale` char(10) NULL DEFAULT \"0\" COMMENT \"     域,1-OS26不结算,2-OS11结算,3-OS24不结算\",\n  `sales_performance_shop_no` char(18) NULL COMMENT \"  \",\n  `sales_performance_shop_name` varchar(100) NULL COMMENT \"  \",\n  `follow_result_type` tinyint(4) NULL COMMENT \"   \",\n  `quality_check_no` varchar(25) NULL COMMENT \"  \",\n  `exchange_curr_code` varchar(18) NULL COMMENT \"  \",\n  `exchange_amount` decimal128(20, 2) NULL COMMENT \"  \",\n  `bookkeeping_third_flag` varchar(50) NULL COMMENT \"  \",\n  `supply_return_no` varchar(25) NULL COMMENT \"  \",\n  `ref_return_no` char(30) NULL COMMENT \"  \"\n) ENGINE=OLAP \nPRIMARY KEY(`business_no`, `out_date`)\nCOMMENT \"  \"\nPARTITION BY RANGE(`out_date`)\n(PARTITION p202304 VALUES [(\"2023-04-01\"), (\"2023-05-01\")),\nPARTITION p202305 VALUES [(\"2023-05-01\"), (\"2023-06-01\")))\nDISTRIBUTED BY HASH(`business_no`) BUCKETS 8 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"bloom_filter_columns\" = \"shop_no\",\n\"dynamic_partition.enable\" = \"true\",\n\"dynamic_partition.time_unit\" = \"month\",\n\"dynamic_partition.time_zone\" = \"Asia/Shanghai\",\n\"dynamic_partition.start\" = \"-2147483648\",\n\"dynamic_partition.end\" = \"1\",\n\"dynamic_partition.prefix\" = \"p\",\n\"dynamic_partition.buckets\" = \"8\",\n\"dynamic_partition.history_partition_num\" = \"0\",\n\"dynamic_partition.start_day_of_month\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"true\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);",
    "retail_pos.shop": "CREATE TABLE `shop` (\n  `shop_no` varchar(18) NOT NULL COMMENT \"  \",\n  `id` int(11) NULL COMMENT \"  \",\n  `code` varchar(18) NULL COMMENT \"  \",\n  `shop_lcode` varchar(18) NULL COMMENT \"  \",\n  `store_no` varchar(18) NULL COMMENT \"  \",\n  `company_no` char(18) NULL COMMENT \"  \",\n  `search_code` varchar(10) NULL COMMENT \"  \",\n  `short_name` varchar(100) NULL COMMENT \"  \",\n  `full_name` varchar(200) NULL COMMENT \"  \",\n  `organ_no` char(18) NULL COMMENT \"   (历史原因从集团接入的数据为  市)\",\n  `biz_city_no` char(18) NULL COMMENT \"  \",\n  `sys_no` varchar(10) NULL DEFAULT \"00\" COMMENT \"  \",\n  `open_date` date NULL COMMENT \"   (店铺正式营  期)\",\n  `close_date` date NULL COMMENT \"   (店铺停止营  期)\",\n  `status` tinyint(4) NULL DEFAULT \"1\" COMMENT \"   0:冻结,1:正常,2:作废,9:撤销)\",\n  `area` decimal64(10, 2) NULL DEFAULT \"0.00\" COMMENT \"    2)\",\n  `area_left` decimal64(10, 2) NULL DEFAULT \"0.00\" COMMENT \"    2)\",\n  `outside_storage_area` decimal64(10, 2) NULL DEFAULT \"0.00\" COMMENT \"    ²)\",\n  `area_total` decimal64(10, 2) NULL DEFAULT \"0.00\" COMMENT \"    2)\",\n  `area_unit` varchar(6) NULL DEFAULT \"1\" COMMENT \"   1:㎡)\",\n  `belle_province_no` varchar(2) NULL COMMENT \"  \",\n  `belle_city_no` varchar(4) NULL COMMENT \"  \",\n  `belle_county_no` varchar(6) NULL COMMENT \"  \",\n  `province_no` varchar(20) NULL COMMENT \"  \",\n  `city_no` varchar(20) NULL COMMENT \"  \",\n  `county_no` varchar(20) NULL COMMENT \"  \",\n  `address` varchar(240) NULL COMMENT \"   (填写时不用包含省  县)\",\n  `zip_code` varchar(10) NULL COMMENT \"  \",\n  `contact_name` varchar(32) NULL COMMENT \"  \",\n  `tel` varchar(100) NULL COMMENT \"  \",\n  `mobile_phone` varchar(64) NULL COMMENT \"  \",\n  `fax` varchar(20) NULL COMMENT \"  \",\n  `email` varchar(64) NULL COMMENT \"  \",\n  `channel_no` char(18) NULL COMMENT \"  \",\n  `location` varchar(20) NULL COMMENT \"  \",\n  `employe_amount` int(11) NULL COMMENT \"   (  填,指标准的店员配备数量)\",\n  `floor_number` varchar(20) NULL COMMENT \"  \",\n  `pay_type` varchar(20) NULL COMMENT \"   (  填, U030301:扣费店 U030302:租金店 U030303:不结算 U030304:保底店)\",\n  `digits` varchar(20) NULL COMMENT \"   (  填, 0:元 1:角 2:分 3:3位小数)\",\n  `startup_time` varchar(10) NULL COMMENT \"  \",\n  `shutdown_time` varchar(10) NULL COMMENT \"  \",\n  `shop_level` varchar(20) NULL COMMENT \"   (从lo  p(主表),lookup_entry(明细表),获取,code:SHOP_LEVEL)\",\n  `major` varchar(20) NULL COMMENT \"    (从lo  p(主表),lookup_entry(明细表),获取,code:MAIN_CATEGORY)\",\n  `multi` varchar(20) NULL COMMENT \"      品(从lookup(主表),lookup_entry(明细表),获取,code:SHOP_CATEGORY_C)\",\n  `sale_mode` varchar(20) NULL COMMENT \"    5:零售店,06:批发店,07:其他店,08:网销店)\",\n  `retail_type` varchar(20) NULL DEFAULT \"A0\" COMMENT \"    (  型(门店必填, 从lookup(主表)获取,lookup_entry(明细表),code:SHOP_CATEGORY_B)\",\n  `mall_no` char(18) NULL COMMENT \"  \",\n  `region_no` char(18) NULL COMMENT \"  \",\n  `cmcdist_no` char(18) NULL COMMENT \"  \",\n  `category_code` varchar(20) NULL COMMENT \"   (从lo  p(主表)获取,lookup_entry(明细表),code:MAIN_CATEGORY)\",\n  `shop_classify` varchar(20) NULL COMMENT \"  \",\n  `price_adjust_level` varchar(20) NULL COMMENT \"  \",\n  `on_line_flag` tinyint(4) NULL DEFAULT \"1\" COMMENT \"   :1在线  线\",\n  `create_user` varchar(32) NULL COMMENT \"  \",\n  `create_time` datetime NULL COMMENT \"  \",\n  `update_user` varchar(32) NULL COMMENT \"  \",\n  `update_time` datetime NULL COMMENT \"  \",\n  `remark` varchar(255) NULL DEFAULT \"\" COMMENT \"  \",\n  `time_seq` bigint(20) NULL COMMENT \"  \",\n  `shop_mode_no` varchar(20) NULL COMMENT \"  \",\n  `organ_type_no` varchar(50) NULL COMMENT \"  \",\n  `corporation_no` varchar(20) NULL COMMENT \"  \",\n  `map_flag` tinyint(4) NULL DEFAULT \"0\" COMMENT \"    是;0否\",\n  `shop_latitude` varchar(60) NULL COMMENT \"  \",\n  `shop_longitude` varchar(60) NULL COMMENT \"  \",\n  `latitude_gaode` varchar(255) NULL COMMENT \"  \",\n  `longitude_gaode` varchar(255) NULL COMMENT \"  \",\n  `customer_no` char(18) NULL COMMENT \"  \",\n  `group_brand` varchar(20) NULL COMMENT \"  \",\n  `logistics_cost_payer` varchar(20) NULL COMMENT \"  \",\n  `shop_property` varchar(20) NULL COMMENT \"  \",\n  `cooperation_model` tinyint(4) NULL DEFAULT \"1\" COMMENT \"   1:自营/2:加盟/3:合伙人/4:代销/5:联营)\",\n  `property_coop_type` varchar(20) NULL COMMENT \"  \",\n  `property_coop_terms` varchar(20) NULL COMMENT \"  \",\n  `competitive_area` varchar(14) NULL COMMENT \"  \",\n  `zone_no` char(18) NULL COMMENT \"  \"\n) ENGINE=OLAP \nPRIMARY KEY(`shop_no`)\nCOMMENT \"   (ot  表-来源mdm)\"\nDISTRIBUTED BY HASH(`shop_no`) BUCKETS 4 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"true\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);",
    "retail_pos.zone_info": "CREATE TABLE `zone_info` (\n  `zone_no` varchar(18) NOT NULL COMMENT \"  \",\n  `id` int(11) NULL COMMENT \"  \",\n  `zone_code` char(2) NULL COMMENT \"   (有且必须只能输入一  位)\",\n  `name` varchar(10) NULL COMMENT \"  \",\n  `status` tinyint(4) NULL DEFAULT \"1\" COMMENT \"   0 = 撤消 1 = 正常)\",\n  `sys_no` varchar(10) NULL DEFAULT \"00\" COMMENT \"    0-通用定义 其他则为相应品牌库)\",\n  `zone_type` tinyint(4) NULL DEFAULT \"0\" COMMENT \"   0:普通地区;1:批发地区;)\",\n  `order_no` int(11) NULL COMMENT \"  \",\n  `create_user` varchar(32) NULL COMMENT \"  \",\n  `create_time` datetime NULL COMMENT \"  \",\n  `update_user` varchar(32) NULL COMMENT \"  \",\n  `update_time` datetime NULL COMMENT \"  \",\n  `remark` varchar(255) NULL DEFAULT \"\" COMMENT \"  \",\n  `time_seq` bigint(20) NULL COMMENT \"  \"\n) ENGINE=OLAP \nPRIMARY KEY(`zone_no`)\nCOMMENT \"   (ot  表-来源mdm)\"\nDISTRIBUTED BY HASH(`zone_no`) BUCKETS 4 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"true\",\n\"replicated_storage\" = \"true\",\n\"compression\" = \"LZ4\"\n);"
  },
  "table_row_count": {},
  "session_variables": "{\"enable_show_all_variables\":true,\"cbo_cte_reuse\":true,\"full_sort_max_buffered_bytes\":16777216,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":false,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"cbo_cte_reuse_rate_v2\":1.15,\"transmission_encode_level\":7,\"character_set_results\":\"utf8\",\"transaction_isolation\":\"REPEATABLE-READ\",\"enable_global_runtime_filter\":true,\"load_transmission_compression_type\":\"NO_COMPRESSION\",\"cbo_enable_low_cardinality_optimize\":true,\"enable_resource_group_v2\":true,\"enable_rewrite_simple_agg_to_meta_scan\":false,\"new_planner_optimize_timeout\":30000000,\"enable_outer_join_reorder\":true,\"enable_adaptive_sink_dop\":false,\"force_schedule_local\":false,\"hudi_mor_force_jni_reader\":false,\"full_sort_late_materialization\":false,\"enable_profile\":false,\"cbo_enable_greedy_join_reorder\":true,\"load_mem_limit\":0,\"range_pruner_max_predicate\":100,\"sql_safe_updates\":0,\"runtime_filter_early_return_selectivity\":0.05,\"enable_local_shuffle_agg\":true,\"rpc_http_min_size\":2147482624,\"cbo_debug_alive_backend_number\":0,\"global_runtime_filter_probe_min_size\":102400,\"enable_parallel_merge\":false,\"nested_mv_rewrite_max_level\":3,\"query_delivery_timeout\":300,\"net_write_timeout\":60,\"cbo_prune_shuffle_column_rate\":0.1,\"collation_database\":\"utf8_general_ci\",\"spill_mem_table_size\":104857600,\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"use_compute_nodes\":-1,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"\",\"broadcast_row_limit\":15000000,\"enable_populate_block_cache\":true,\"profile_limit_fold\":true,\"spill_operator_max_bytes\":1048576000,\"exec_mem_limit\":2147483648,\"enable_sort_aggregate\":false,\"cbo_max_reorder_node_use_dp\":10,\"query_cache_force_populate\":false,\"runtime_filter_on_exchange_node\":false,\"disable_join_reorder\":false,\"enable_rule_based_materialized_view_rewrite\":true,\"enable_hive_column_stats\":true,\"enable_groupby_use_output_alias\":false,\"net_buffer_length\":16384,\"forward_to_leader\":false,\"count_distinct_column_buckets\":1024,\"full_sort_max_buffered_rows\":1024000,\"query_cache_agg_cardinality_limit\":5000000,\"query_timeout\":300,\"enable_pipeline_query_statistic\":true,\"cbo_max_reorder_node\":50,\"cboPushDownAggregateMode_v1\":-1,\"window_partition_mode\":1,\"enable_deliver_batch_fragments\":true,\"enable_tablet_internal_parallel_v2\":true,\"enable_distinct_column_bucketization\":true,\"enable_big_query_log\":true,\"interpolate_passthrough\":true,\"enable_incremental_mv\":false,\"analyze_mv\":\"sample\",\"runtime_filter_scan_wait_time\":20,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"prefer_compute_node\":false,\"max_pipeline_dop\":64,\"broadcast_right_table_scale_factor\":10,\"group_concat_max_len\":65535,\"parse_tokens_limit\":3500000,\"chunk_size\":4096,\"runtime_join_filter_push_down_limit\":1024000,\"global_runtime_filter_probe_min_selectivity\":0.5,\"query_mem_limit\":0,\"enable_filter_unused_columns_in_scan_stage\":true,\"big_query_log_cpu_second_threshold\":480,\"enable_scan_block_cache\":false,\"enable_materialized_view_single_table_view_delta_rewrite\":false,\"div_precision_increment\":4,\"runtime_adaptive_dop_max_block_rows_per_driver_seq\":16384,\"log_rejected_record_num\":0,\"auto_increment_increment\":1,\"sql_dialect\":\"StarRocks\",\"cbo_push_down_distinct_below_window\":true,\"sql_mode_v2\":34,\"big_query_log_scan_rows_threshold\":1000000000,\"character_set_client\":\"utf8\",\"autocommit\":true,\"hdfs_backend_selector_scan_range_shuffle\":false,\"enable_column_expr_predicate\":true,\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"enable_runtime_adaptive_dop\":false,\"cbo_cte_max_limit\":10,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"hive_partition_stats_sample_size\":3000,\"enable_optimizer_trace_log\":false,\"enable_mv_planner\":false,\"spill_operator_min_bytes\":10485760,\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"enable_materialized_view_view_delta_rewrite\":true,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"spill_mem_table_num\":2,\"profile_timeout\":2,\"cbo_push_down_aggregate\":\"global\",\"enable_spill\":false,\"pipeline_dop\":0,\"enable_query_dump\":false,\"single_node_exec_plan\":false,\"join_implementation_mode_v2\":\"auto\",\"global_runtime_filter_build_max_size\":67108864,\"sql_select_limit\":9223372036854775807,\"enable_materialized_view_rewrite\":true,\"statistic_collect_parallel\":1,\"enable_rewrite_sum_by_associative_rule\":true,\"query_cache_hot_partition_num\":3,\"enable_prune_complex_types\":true,\"query_cache_type\":0,\"disable_colocate_join\":false,\"max_parallel_scan_instance_num\":-1,\"query_cache_entry_max_rows\":409600,\"max_pushdown_conditions_per_column\":-1,\"connector_io_tasks_per_scan_operator\":16,\"default_table_compression\":\"lz4_frame\",\"enable_materialized_view_union_rewrite\":true,\"runtime_adaptive_dop_max_output_amplification_factor\":0,\"sql_quote_show_create\":true,\"enable_exchange_pass_through\":true,\"query_cache_entry_max_bytes\":4194304,\"innodb_read_only\":true,\"spill_mem_limit_threshold\":0.5,\"cbo_reorder_threshold_use_exhaustive\":6,\"enable_exchange_perf\":false,\"enable_predicate_reorder\":false,\"workgroup_id\":0,\"enable_query_cache\":false,\"enable_rewrite_groupingsets_to_union_all\":false,\"transmission_compression_type\":\"NO_COMPRESSION\",\"interactive_timeout\":3600,\"max_allowed_packet\":1048576,\"big_query_log_scan_bytes_threshold\":10737418240,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Asia/Shanghai\",\"enable_multicolumn_global_runtime_filter\":false,\"character_set_server\":\"utf8\",\"tablet_internal_parallel_mode\":\"auto\",\"enable_pipeline\":true,\"cbo_use_nth_exec_plan\":0,\"io_tasks_per_scan_operator\":4,\"spill_mode\":\"auto\",\"parallel_exchange_instance_num\":-1,\"enable_shared_scan\":false,\"enable_query_debug_trace\":false,\"allow_default_partition\":false}",
  "column_statistics": {
    "retail_pos.return_exchange_dtl": {
      "sharding_flag": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "brand_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "business_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "qty": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "retail_pos.order_main": {
      "order_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "sharding_flag": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "business_type": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "out_date": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "shop_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "status": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "retail_pos.zone_info": {
      "zone_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "retail_pos.organ": {
      "organ_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "zone_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "retail_pos.bill_check_diff": {
      "sharding_flag": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "check_date": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "store_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "check_type": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "bill_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "status": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "retail_pos.bill_check_diff_dtl": {
      "diff_qty": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "sharding_flag": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "order_unit_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "brand_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "bill_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "retail_pos.shop": {
      "shop_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "retail_pos.bill_checkstk": {
      "sharding_flag": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "check_date": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "store_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "check_type": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "bill_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "id": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "status": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "retail_pos.order_unit": {
      "order_unit_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "organ_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "retail_pos.inventory_book": {
      "sharding_flag": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "order_unit_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "bill_date": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "brand_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "store_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "retail_pos.brand": {
      "brand_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "sys_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "retail_pos.return_exchange_main": {
      "sharding_flag": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "business_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "out_date": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "business_mode": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "status": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "shop_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "retail_pos.brand_unit": {
      "brand_unit_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "retail_pos.bill_checkstk_dtl": {
      "sharding_flag": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "order_unit_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "brand_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "real_qty": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "bill_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "retail_pos.order_dtl": {
      "order_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "sharding_flag": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "brand_no": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "qty": "[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    }
  },
  "be_number": 1,
  "be_core_stat": {
    "numOfHardwareCoresPerBe": "{\"10004\":104}",
    "cachedAvgNumOfHardwareCores": 104
  },
  "exception": [],
  "version": "UNKNOWN",
  "commit_version": "d9e7031eae"
}